USE [wdms]
GO

-- =============================================
-- Author     :		Lohith Ram D V
-- Create date:         08/mar/2011
-- =============================================

create procedure sp_IsUserExist(
	@par_username nchar(100))
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	IF EXISTS(SELECT * FROM [User1] WHERE [User1].[user1_name]=@par_username) RETURN 1;
	ELSE RETURN 0;
	/* SET NOCOUNT ON */
	RETURN
